Data Profiling Report

Brought to you by YData

Dataset statistics

Number of variables	12
Number of observations	43778
Missing cells	6
Missing cells (%)	< 0.1%
Duplicate rows	0
Duplicate rows (%)	0.0%
Total size in memory	4.3 MiB
Average record size in memory	104.0 B

Variable types

DateTime	1
Numeric	11

Alerts

`DE_load_actual_entsoe_transparency` is highly overall correlated with `Price (EUR/MWhe)`	High correlation
`DE_radiation_diffuse_horizontal` is highly overall correlated with `DE_radiation_direct_horizontal` and 1 other fields	High correlation
`DE_radiation_direct_horizontal` is highly overall correlated with `DE_radiation_diffuse_horizontal` and 2 other fields	High correlation
`DE_solar_capacity` is highly overall correlated with `DE_wind_capacity` and 1 other fields	High correlation
`DE_solar_generation_actual` is highly overall correlated with `DE_radiation_diffuse_horizontal` and 2 other fields	High correlation
`DE_temperature` is highly overall correlated with `DE_radiation_direct_horizontal` and 1 other fields	High correlation
`DE_wind_capacity` is highly overall correlated with `DE_solar_capacity` and 1 other fields	High correlation
`Oil_Price` is highly overall correlated with `DE_solar_capacity` and 1 other fields	High correlation
`Price (EUR/MWhe)` is highly overall correlated with `DE_load_actual_entsoe_transparency`	High correlation
`cet_cest_timestamp` has unique values	Unique
`DE_solar_generation_actual` has 18985 (43.4%) zeros	Zeros
`DE_radiation_direct_horizontal` has 18724 (42.8%) zeros	Zeros
`DE_radiation_diffuse_horizontal` has 18724 (42.8%) zeros	Zeros

Reproduction

Analysis started	2025-04-21 14:29:10.913747
Analysis finished	2025-04-21 14:29:44.929787
Duration	34.02 seconds
Software version	ydata-profiling v0.0.dev0
Download configuration	config.json

cet_cest_timestamp
Date

Unique

Distinct	43778
Distinct (%)	100.0%
Missing	0
Missing (%)	0.0%
Memory size	684.0 KiB

Minimum	2015-01-01 00:00:00+01:00
Maximum	2019-12-30 01:00:00+01:00
Invalid dates	25704
Invalid dates (%)	58.7%

Histogram with fixed size bins (bins=50)

DE_load_actual_entsoe_transparency
Real number (ℝ)

High correlation

Distinct	25332
Distinct (%)	57.9%
Missing	1
Missing (%)	< 0.1%
Infinite	0
Infinite (%)	0.0%
Mean	55867.097

Minimum	31307
Maximum	77549
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	684.0 KiB

Quantile statistics

Minimum	31307
5-th percentile	40239.8
Q1	47440
median	55484
Q3	64796
95-th percentile	70968.2
Maximum	77549
Range	46242
Interquartile range (IQR)	17356

Descriptive statistics

Standard deviation	10006.677
Coefficient of variation (CV)	0.17911574
Kurtosis	-1.1320954
Mean	55867.097
Median Absolute Deviation (MAD)	8680
Skewness	-0.034148836
Sum	2.4456939 × 10⁹
Variance	1.0013358 × 10⁸
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
46724	8	< 0.1%
45129	8	< 0.1%
66809	7	< 0.1%
63092	7	< 0.1%
47964	7	< 0.1%
58055	7	< 0.1%
53534	7	< 0.1%
51016	7	< 0.1%
44841	7	< 0.1%
42851	7	< 0.1%
Other values (25322)	43705	99.8%

Value	Count	Frequency (%)
31307	1	< 0.1%
31335	1	< 0.1%
31598	1	< 0.1%
31772	1	< 0.1%
32418	1	< 0.1%
32617	1	< 0.1%
32625	1	< 0.1%
32636	1	< 0.1%
32824	1	< 0.1%
32889	1	< 0.1%

Value	Count	Frequency (%)
77549	1	< 0.1%
76925	1	< 0.1%
76904	1	< 0.1%
76871	1	< 0.1%
76783	1	< 0.1%
76602	1	< 0.1%
76574	1	< 0.1%
76552	1	< 0.1%
76551	1	< 0.1%
76538	1	< 0.1%

DE_solar_capacity
Real number (ℝ)

High correlation

Distinct	1464
Distinct (%)	3.3%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	42373.93

Minimum	37248
Maximum	50508
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	684.0 KiB

Quantile statistics

Minimum	37248
5-th percentile	37531
Q1	38810
median	40941
Q3	46092
95-th percentile	50169
Maximum	50508
Range	13260
Interquartile range (IQR)	7282

Descriptive statistics

Standard deviation	4303.6143
Coefficient of variation (CV)	0.10156279
Kurtosis	-0.98120024
Mean	42373.93
Median Absolute Deviation (MAD)	2513
Skewness	0.68489035
Sum	1.8550459 × 10⁹
Variance	18521096
Monotonicity	Increasing

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
37531	120	0.3%
38789	119	0.3%
49191	96	0.2%
41702	96	0.2%
50507	96	0.2%
37367	96	0.2%
37649	96	0.2%
39942	96	0.2%
37372	96	0.2%
39374	96	0.2%
Other values (1454)	42771	97.7%

Value	Count	Frequency (%)
37248	24	0.1%
37250	72	0.2%
37252	24	0.1%
37253	24	0.1%
37256	24	0.1%
37258	24	0.1%
37260	72	0.2%
37263	24	0.1%
37264	24	0.1%
37266	24	0.1%

Value	Count	Frequency (%)
50508	74	0.2%
50507	96	0.2%
50506	48	0.1%
50505	24	0.1%
50502	24	0.1%
50499	24	0.1%
50485	24	0.1%
50481	24	0.1%
50479	72	0.2%
50478	24	0.1%

DE_solar_generation_actual
Real number (ℝ)

High correlation Zeros

Distinct	13490
Distinct (%)	30.8%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	4303.0678

Minimum	0
Maximum	30028
Zeros	18985
Zeros (%)	43.4%
Negative	0
Negative (%)	0.0%
Memory size	684.0 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	126
Q3	6818
95-th percentile	19359.15
Maximum	30028
Range	30028
Interquartile range (IQR)	6818

Descriptive statistics

Standard deviation	6601.6531
Coefficient of variation (CV)	1.5341736
Kurtosis	1.4031231
Mean	4303.0678
Median Absolute Deviation (MAD)	126
Skewness	1.5564744
Sum	1.883797 × 10⁸
Variance	43581824
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	18985	43.4%
1	280	0.6%
2	181	0.4%
3	147	0.3%
4	99	0.2%
5	90	0.2%
6	64	0.1%
7	64	0.1%
8	58	0.1%
9	45	0.1%
Other values (13480)	23765	54.3%

Value	Count	Frequency (%)
0	18985	43.4%
0.5	1	< 0.1%
1	280	0.6%
1.5	1	< 0.1%
2	181	0.4%
3	147	0.3%
4	99	0.2%
5	90	0.2%
6	64	0.1%
7	64	0.1%

Value	Count	Frequency (%)
30028	1	< 0.1%
29967	1	< 0.1%
29913	1	< 0.1%
29849	1	< 0.1%
29813	1	< 0.1%
29722	1	< 0.1%
29708	1	< 0.1%
29685	1	< 0.1%
29651	1	< 0.1%
29624	1	< 0.1%

DE_wind_capacity
Real number (ℝ)

High correlation

Distinct	1367
Distinct (%)	3.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	39967.34

Minimum	27913
Maximum	50452
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	684.0 KiB

Quantile statistics

Minimum	27913
5-th percentile	28882
Q1	33737
median	39808
Q3	47730
95-th percentile	50059
Maximum	50452
Range	22539
Interquartile range (IQR)	13993

Descriptive statistics

Standard deviation	7260.8091
Coefficient of variation (CV)	0.18166856
Kurtosis	-1.3866005
Mean	39967.34
Median Absolute Deviation (MAD)	6685
Skewness	-0.02370818
Sum	1.7496902 × 10⁹
Variance	52719349
Monotonicity	Increasing

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
44841	264	0.6%
48974	192	0.4%
48249	168	0.4%
49364	168	0.4%
49429	144	0.3%
49300	144	0.3%
49014	144	0.3%
50074	144	0.3%
49370	144	0.3%
32812	144	0.3%
Other values (1357)	42122	96.2%

Value	Count	Frequency (%)
27913	24	0.1%
27926	72	0.2%
27939	24	0.1%
27950	24	0.1%
27957	24	0.1%
27966	24	0.1%
27972	72	0.2%
27976	24	0.1%
27982	24	0.1%
27988	48	0.1%

Value	Count	Frequency (%)
50452	2	< 0.1%
50434	24	0.1%
50427	48	0.1%
50424	96	0.2%
50409	24	0.1%
50403	24	0.1%
50399	24	0.1%
50370	24	0.1%
50361	24	0.1%
50345	24	0.1%

DE_wind_generation_actual
Real number (ℝ)

Distinct	21472
Distinct (%)	49.0%
Missing	1
Missing (%)	< 0.1%
Infinite	0
Infinite (%)	0.0%
Mean	11147.869

Minimum	135
Maximum	45085
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	684.0 KiB

Quantile statistics

Minimum	135
5-th percentile	1494
Q1	4423
median	8726
Q3	15562
95-th percentile	29300.2
Maximum	45085
Range	44950
Interquartile range (IQR)	11139

Descriptive statistics

Standard deviation	8682.6073
Coefficient of variation (CV)	0.77885803
Kurtosis	0.77542329
Mean	11147.869
Median Absolute Deviation (MAD)	5041
Skewness	1.1340622
Sum	4.8802026 × 10⁸
Variance	75387669
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
3879	10	< 0.1%
3336	10	< 0.1%
4853	10	< 0.1%
3165	10	< 0.1%
7892	10	< 0.1%
4506	9	< 0.1%
4207	9	< 0.1%
4826	9	< 0.1%
2477	9	< 0.1%
2952	9	< 0.1%
Other values (21462)	43682	99.8%

Value	Count	Frequency (%)
135	1	< 0.1%
153	2	< 0.1%
163	1	< 0.1%
165	1	< 0.1%
177	1	< 0.1%
189	1	< 0.1%
192	1	< 0.1%
203	2	< 0.1%
205	1	< 0.1%
207	1	< 0.1%

Value	Count	Frequency (%)
45085	1	< 0.1%
45058	1	< 0.1%
44629	1	< 0.1%
44503	1	< 0.1%
44367	1	< 0.1%
44350	1	< 0.1%
44226	1	< 0.1%
44192	1	< 0.1%
44089	1	< 0.1%
43870	1	< 0.1%

Price (EUR/MWhe)
Real number (ℝ)

High correlation

Distinct	7314
Distinct (%)	16.7%
Missing	1
Missing (%)	< 0.1%
Infinite	0
Infinite (%)	0.0%
Mean	35.2341

Minimum	-130.09
Maximum	163.52
Zeros	7
Zeros (%)	< 0.1%
Negative	646
Negative (%)	1.5%
Memory size	684.0 KiB

Quantile statistics

Minimum	-130.09
5-th percentile	12.03
Q1	27.06
median	34.93
Q3	43.82
95-th percentile	58.12
Maximum	163.52
Range	293.61
Interquartile range (IQR)	16.76

Descriptive statistics

Standard deviation	15.387706
Coefficient of variation (CV)	0.43672766
Kurtosis	6.2495879
Mean	35.2341
Median Absolute Deviation (MAD)	8.27
Skewness	-0.22802057
Sum	1542443.2
Variance	236.7815
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
22.34	105	0.2%
40	58	0.1%
30	56	0.1%
35	53	0.1%
34.94	50	0.1%
39.9	42	0.1%
42	41	0.1%
33	39	0.1%
34.9	39	0.1%
32	39	0.1%
Other values (7304)	43255	98.8%

Value	Count	Frequency (%)
-130.09	1	< 0.1%
-100.06	1	< 0.1%
-83.06	1	< 0.1%
-83.04	1	< 0.1%
-83.03	1	< 0.1%
-83.02	1	< 0.1%
-83.01	1	< 0.1%
-83	2	< 0.1%
-82.06	1	< 0.1%
-81.95	1	< 0.1%

Value	Count	Frequency (%)
163.52	1	< 0.1%
153.67	1	< 0.1%
151.07	1	< 0.1%
150.1	1	< 0.1%
143.09	1	< 0.1%
142.78	1	< 0.1%
138.91	1	< 0.1%
135	1	< 0.1%
133.18	1	< 0.1%
131.01	1	< 0.1%

DE_temperature
Real number (ℝ)

High correlation

Distinct	23390
Distinct (%)	53.4%
Missing	1
Missing (%)	< 0.1%
Infinite	0
Infinite (%)	0.0%
Mean	9.8602105

Minimum	-12.686
Maximum	35.479
Zeros	1
Zeros (%)	< 0.1%
Negative	4663
Negative (%)	10.7%
Memory size	684.0 KiB

Quantile statistics

Minimum	-12.686
5-th percentile	-1.983
Q1	3.273
median	9.249
Q3	16.034
95-th percentile	23.631
Maximum	35.479
Range	48.165
Interquartile range (IQR)	12.761

Descriptive statistics

Standard deviation	8.1292512
Coefficient of variation (CV)	0.82445006
Kurtosis	-0.65315928
Mean	9.8602105
Median Absolute Deviation (MAD)	6.334
Skewness	0.23866449
Sum	431650.44
Variance	66.084725
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
6.99	9	< 0.1%
16.978	8	< 0.1%
12.66	8	< 0.1%
4.291	8	< 0.1%
13.112	8	< 0.1%
3.262	8	< 0.1%
9.167	7	< 0.1%
4.532	7	< 0.1%
1.202	7	< 0.1%
1.76	7	< 0.1%
Other values (23380)	43700	99.8%

Value	Count	Frequency (%)
-12.686	1	< 0.1%
-12.507	1	< 0.1%
-12.353	1	< 0.1%
-11.988	1	< 0.1%
-11.619	1	< 0.1%
-11.212	1	< 0.1%
-11.146	1	< 0.1%
-11.062	1	< 0.1%
-11.027	1	< 0.1%
-10.955	1	< 0.1%

Value	Count	Frequency (%)
35.479	1	< 0.1%
35.374	1	< 0.1%
35.248	1	< 0.1%
34.952	1	< 0.1%
34.713	1	< 0.1%
34.373	1	< 0.1%
34.317	1	< 0.1%
34.298	1	< 0.1%
34.176	1	< 0.1%
34.172	1	< 0.1%

DE_radiation_direct_horizontal
Real number (ℝ)

High correlation Zeros

Distinct	25054
Distinct (%)	57.2%
Missing	1
Missing (%)	< 0.1%
Infinite	0
Infinite (%)	0.0%
Mean	82.819672

Minimum	0
Maximum	841.68104
Zeros	18724
Zeros (%)	42.8%
Negative	0
Negative (%)	0.0%
Memory size	684.0 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0.42644003
Q3	79.325396
95-th percentile	475.45788
Maximum	841.68104
Range	841.68104
Interquartile range (IQR)	79.325396

Descriptive statistics

Standard deviation	159.06547
Coefficient of variation (CV)	1.9206242
Kurtosis	4.310132
Mean	82.819672
Median Absolute Deviation (MAD)	0.42644003
Skewness	2.2263327
Sum	3625596.8
Variance	25301.823
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	18724	42.8%
7.95798668	1	< 0.1%
9.379364792	1	< 0.1%
3.822047998	1	< 0.1%
70.51504672	1	< 0.1%
18.89479469	1	< 0.1%
10.5469209	1	< 0.1%
0.2799298852	1	< 0.1%
0.4327949255	1	< 0.1%
8.877348817	1	< 0.1%
Other values (25044)	25044	57.2%

Value	Count	Frequency (%)
0	18724	42.8%
8.171790981 × 10^-7	1	< 0.1%
9.07846013 × 10^-7	1	< 0.1%
9.530085836 × 10^-7	1	< 0.1%
1.045591789 × 10^-6	1	< 0.1%
1.06322559 × 10^-6	1	< 0.1%
1.07193191 × 10^-6	1	< 0.1%
1.14164887 × 10^-6	1	< 0.1%
1.141725265 × 10^-6	1	< 0.1%
1.173996657 × 10^-6	1	< 0.1%

Value	Count	Frequency (%)
841.6810378	1	< 0.1%
841.2403306	1	< 0.1%
840.6881976	1	< 0.1%
831.5056881	1	< 0.1%
829.7901916	1	< 0.1%
827.1609402	1	< 0.1%
822.3007002	1	< 0.1%
818.5285918	1	< 0.1%
814.5623326	1	< 0.1%
813.3931179	1	< 0.1%

DE_radiation_diffuse_horizontal
Real number (ℝ)

High correlation Zeros

Distinct	25054
Distinct (%)	57.2%
Missing	1
Missing (%)	< 0.1%
Infinite	0
Infinite (%)	0.0%
Mean	67.120673

Minimum	0
Maximum	392.08953
Zeros	18724
Zeros (%)	42.8%
Negative	0
Negative (%)	0.0%
Memory size	684.0 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	6.3509196
Q3	119.66999
95-th percentile	254.93552
Maximum	392.08953
Range	392.08953
Interquartile range (IQR)	119.66999

Descriptive statistics

Standard deviation	89.201568
Coefficient of variation (CV)	1.3289731
Kurtosis	0.74047776
Mean	67.120673
Median Absolute Deviation (MAD)	6.3509196
Skewness	1.2607732
Sum	2938341.7
Variance	7956.9197
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	18724	42.8%
100.6625133	1	< 0.1%
108.5543352	1	< 0.1%
45.275952	1	< 0.1%
81.73645328	1	< 0.1%
51.04470531	1	< 0.1%
112.3496791	1	< 0.1%
2.273970115	1	< 0.1%
6.768005075	1	< 0.1%
51.94635118	1	< 0.1%
Other values (25044)	25044	57.2%

Value	Count	Frequency (%)
0	18724	42.8%
8.675676469 × 10^-5	1	< 0.1%
8.78007015 × 10^-5	1	< 0.1%
8.7845987 × 10^-5	1	< 0.1%
8.795196726 × 10^-5	1	< 0.1%
9.074600853 × 10^-5	1	< 0.1%
9.07794107 × 10^-5	1	< 0.1%
9.173733963 × 10^-5	1	< 0.1%
9.225912742 × 10^-5	1	< 0.1%
9.230272995 × 10^-5	1	< 0.1%

Value	Count	Frequency (%)
392.0895324	1	< 0.1%
390.2950449	1	< 0.1%
389.785004	1	< 0.1%
389.722721	1	< 0.1%
387.7550278	1	< 0.1%
385.454346	1	< 0.1%
384.7493436	1	< 0.1%
384.68629	1	< 0.1%
384.6193791	1	< 0.1%
384.2284195	1	< 0.1%

Gas_Price
Real number (ℝ)

Distinct	220
Distinct (%)	0.5%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	2.7684353

Minimum	1.49
Maximum	6.24
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	684.0 KiB

Quantile statistics

Minimum	1.49
5-th percentile	1.91
Q1	2.54
median	2.79
Q3	2.98
95-th percentile	3.56
Maximum	6.24
Range	4.75
Interquartile range (IQR)	0.44

Descriptive statistics

Standard deviation	0.50564694
Coefficient of variation (CV)	0.1826472
Kurtosis	4.5642933
Mean	2.7684353
Median Absolute Deviation (MAD)	0.21
Skewness	0.92941831
Sum	121196.56
Variance	0.25567883
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
2.88	1200	2.7%
2.75	1104	2.5%
2.96	912	2.1%
2.89	816	1.9%
2.76	768	1.8%
2.7	720	1.6%
2.95	672	1.5%
2.98	672	1.5%
2.78	672	1.5%
2.91	672	1.5%
Other values (210)	35570	81.3%

Value	Count	Frequency (%)
1.49	72	0.2%
1.56	24	0.1%
1.57	24	0.1%
1.59	24	0.1%
1.6	48	0.1%
1.61	24	0.1%
1.62	24	0.1%
1.63	120	0.3%
1.66	24	0.1%
1.68	24	0.1%

Value	Count	Frequency (%)
6.24	48	0.1%
5.46	24	0.1%
4.7	120	0.3%
4.69	48	0.1%
4.65	144	0.3%
4.61	72	0.2%
4.54	24	0.1%
4.53	48	0.1%
4.51	72	0.2%
4.5	48	0.1%

Oil_Price
Real number (ℝ)

High correlation

Distinct	1064
Distinct (%)	2.4%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	57.09679

Minimum	26.01
Maximum	86.07
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	684.0 KiB

Quantile statistics

Minimum	26.01
5-th percentile	37.22
Q1	48.1
median	57.02
Q3	65.02
95-th percentile	75.89
Maximum	86.07
Range	60.06
Interquartile range (IQR)	16.92

Descriptive statistics

Standard deviation	11.529101
Coefficient of variation (CV)	0.20192206
Kurtosis	-0.480539
Mean	57.09679
Median Absolute Deviation (MAD)	8.53
Skewness	-0.039511655
Sum	2499583.3
Variance	132.92018
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
54.8	168	0.4%
46.69	168	0.4%
55.73	144	0.3%
70.71	144	0.3%
64.68	144	0.3%
69.02	144	0.3%
61.04	144	0.3%
47.28	144	0.3%
51.93	144	0.3%
38.33	120	0.3%
Other values (1054)	42314	96.7%

Value	Count	Frequency (%)
26.01	24	0.1%
27.36	48	0.1%
27.59	24	0.1%
28.58	24	0.1%
28.8	72	0.2%
28.82	24	0.1%
28.84	24	0.1%
29.14	24	0.1%
29.64	24	0.1%
29.82	24	0.1%

Value	Count	Frequency (%)
86.07	24	0.1%
85.63	24	0.1%
85.45	24	0.1%
85.16	24	0.1%
85.12	72	0.2%
84.94	24	0.1%
84.22	24	0.1%
83.82	24	0.1%
82.72	72	0.2%
82.21	24	0.1%

	DE_load_actual_entsoe_transparency	DE_radiation_diffuse_horizontal	DE_radiation_direct_horizontal	DE_solar_capacity	DE_solar_generation_actual	DE_temperature	DE_wind_capacity	DE_wind_generation_actual	Gas_Price	Oil_Price	Price (EUR/MWhe)
DE_load_actual_entsoe_transparency	1.000	0.457	0.443	0.044	0.454	-0.054	0.043	0.071	0.060	0.023	0.545
DE_radiation_diffuse_horizontal	0.457	1.000	0.941	-0.014	0.951	0.470	-0.014	-0.150	-0.031	0.023	0.107
DE_radiation_direct_horizontal	0.443	0.941	1.000	-0.007	0.985	0.507	-0.007	-0.206	-0.028	0.046	0.102
DE_solar_capacity	0.044	-0.014	-0.007	1.000	0.010	0.080	1.000	0.227	0.076	0.644	0.336
DE_solar_generation_actual	0.454	0.951	0.985	0.010	1.000	0.502	0.010	-0.183	-0.034	0.049	0.093
DE_temperature	-0.054	0.470	0.507	0.080	0.502	1.000	0.080	-0.243	-0.037	0.083	-0.037
DE_wind_capacity	0.043	-0.014	-0.007	1.000	0.010	0.080	1.000	0.227	0.076	0.644	0.336
DE_wind_generation_actual	0.071	-0.150	-0.206	0.227	-0.183	-0.243	0.227	1.000	0.024	0.122	-0.274
Gas_Price	0.060	-0.031	-0.028	0.076	-0.034	-0.037	0.076	0.024	1.000	0.255	0.231
Oil_Price	0.023	0.023	0.046	0.644	0.049	0.083	0.644	0.122	0.255	1.000	0.359
Price (EUR/MWhe)	0.545	0.107	0.102	0.336	0.093	-0.037	0.336	-0.274	0.231	0.359	1.000

A simple visualization of nullity by column.

Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.

The correlation heatmap measures nullity correlation: how strongly the presence or absence of one variable affects the presence of another.

	cet_cest_timestamp	DE_load_actual_entsoe_transparency	DE_solar_capacity	DE_solar_generation_actual	DE_wind_capacity	DE_wind_generation_actual	Price (EUR/MWhe)	DE_temperature	DE_radiation_direct_horizontal	DE_radiation_diffuse_horizontal	Gas_Price	Oil_Price
utc_timestamp
2014-12-31 23:00:00	2015-01-01T00:00:00+0100	NaN	37248.0	0.0	27913.0	NaN	NaN	NaN	NaN	NaN	3.14	55.38
2015-01-01 00:00:00	2015-01-01T01:00:00+0100	41151.0	37248.0	0.0	27913.0	8852.0	22.34	-0.981	0.000000	0.000000	3.14	55.38
2015-01-01 01:00:00	2015-01-01T02:00:00+0100	40135.0	37248.0	0.0	27913.0	9054.0	22.34	-1.035	0.000000	0.000000	3.14	55.38
2015-01-01 02:00:00	2015-01-01T03:00:00+0100	39106.0	37248.0	0.0	27913.0	9070.0	22.34	-1.109	0.000000	0.000000	3.14	55.38
2015-01-01 03:00:00	2015-01-01T04:00:00+0100	38765.0	37248.0	0.0	27913.0	9163.0	22.34	-1.166	0.000000	0.000000	3.14	55.38
2015-01-01 04:00:00	2015-01-01T05:00:00+0100	38941.0	37248.0	0.0	27913.0	9231.0	22.34	-1.226	0.000000	0.000000	3.14	55.38
2015-01-01 05:00:00	2015-01-01T06:00:00+0100	39045.0	37248.0	0.0	27913.0	9689.0	22.34	-1.305	0.000000	0.000000	3.14	55.38
2015-01-01 06:00:00	2015-01-01T07:00:00+0100	40206.0	37248.0	0.0	27913.0	10331.0	22.34	-1.478	0.000000	0.000000	3.14	55.38
2015-01-01 07:00:00	2015-01-01T08:00:00+0100	41133.0	37248.0	71.0	27913.0	10208.0	22.34	-1.692	0.432795	6.768005	3.14	55.38
2015-01-01 08:00:00	2015-01-01T09:00:00+0100	42963.0	37248.0	773.0	27913.0	10029.0	22.34	-1.046	8.877349	51.946351	3.14	55.38

	cet_cest_timestamp	DE_load_actual_entsoe_transparency	DE_solar_capacity	DE_solar_generation_actual	DE_wind_capacity	DE_wind_generation_actual	Price (EUR/MWhe)	DE_temperature	DE_radiation_direct_horizontal	DE_radiation_diffuse_horizontal	Gas_Price	Oil_Price
utc_timestamp
2019-12-29 15:00:00	2019-12-29T16:00:00+0100	49244.0	50508.0	105.0	50434.0	14808.0	34.47	-0.929	0.27993	2.27397	1.75	68.91
2019-12-29 16:00:00	2019-12-29T17:00:00+0100	52332.0	50508.0	0.0	50434.0	16721.0	39.81	-0.982	0.00000	0.00000	1.75	68.91
2019-12-29 17:00:00	2019-12-29T18:00:00+0100	52958.0	50508.0	0.0	50434.0	18357.0	40.47	-0.873	0.00000	0.00000	1.75	68.91
2019-12-29 18:00:00	2019-12-29T19:00:00+0100	51943.0	50508.0	0.0	50434.0	19397.0	38.96	-0.880	0.00000	0.00000	1.75	68.91
2019-12-29 19:00:00	2019-12-29T20:00:00+0100	49806.0	50508.0	0.0	50434.0	19506.0	35.35	-0.959	0.00000	0.00000	1.75	68.91
2019-12-29 20:00:00	2019-12-29T21:00:00+0100	48362.0	50508.0	0.0	50434.0	20610.0	30.47	-1.015	0.00000	0.00000	1.75	68.91
2019-12-29 21:00:00	2019-12-29T22:00:00+0100	47950.0	50508.0	0.0	50434.0	21107.0	28.64	-1.038	0.00000	0.00000	1.75	68.91
2019-12-29 22:00:00	2019-12-29T23:00:00+0100	45146.0	50508.0	0.0	50434.0	21740.0	23.06	-1.079	0.00000	0.00000	1.75	68.91
2019-12-29 23:00:00	2019-12-30T00:00:00+0100	43026.0	50508.0	0.0	50452.0	22553.0	13.54	-1.138	0.00000	0.00000	1.75	68.91
2019-12-30 00:00:00	2019-12-30T01:00:00+0100	41138.0	50508.0	0.0	50452.0	22793.0	11.42	-1.162	0.00000	0.00000	2.06	68.30

Overview

Interactions

Correlations

Missing values

Sample

Overview

Variables

Interactions

Correlations

Missing values

Sample